Tabela Referral

Definicja tabeli Referral

Name

Referral

Code

Referral

Comment

PL: Dane skierowania
EN: Referral data


Lista kolumn tabeli Referral

Name

Code

ReferralID

ReferralID

ReferralSourceID

ReferralSourceID

ReferralModeID

ReferralModeID

ExternalOrgUnitID

ExternalOrgUnitID

ExternalDoctorID

ExternalDoctorID

PreviousTreatmentPlaceID

PreviousTreatmentPlaceID

ICDID

ICDID

StartDT

StartDT

StopDT

StopDT

VisitCount

VisitCount

OrderingCompanyStatisticalNo

OrderingCompanyStatisticalNo

OrderingOrgUnitType

OrderingOrgUnitType

OrderingDoctor

OrderingDoctor

OrderingDoctorNo

OrderingDoctorNo

CustomerContractNo

CustomerContractNo

OrderingUnitID

OrderingUnitID

OrdDocumentNo

OrdDocumentNo

Comments

Comments

Charge

Charge

ExternalDocumentNo

ExternalDocumentNo

PerformingDoctor

PerformingDoctor

RefusingExternalOrgUnitID

RefusingExternalOrgUnitID

ReferralDoctorID

ReferralDoctorID

StatCode8thPartID

StatCode8thPartID

PersonID

PersonID

SourceEventID

SourceEventID

OccupationExamTypeID

OccupationExamTypeID

HospitalizationPurposeID

HospitalizationPurposeID

DestinationOrgUnitID

DestinationOrgUnitID

ReceivedDT

ReceivedDT

IsInternal

IsInternal

ExternalOrgUnitName

ExternalOrgUnitName

Occupation

Occupation

IcdComment

IcdComment

Commentary

Commentary


Kolumna ReferralID tabeli Referral

Definicja kolumny ReferralID tabeli Referral

Name

ReferralID

Code

ReferralID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID Skierowania


Kolumna ReferralSourceID tabeli Referral

Definicja kolumny ReferralSourceID tabeli Referral

Name

ReferralSourceID

Code

ReferralSourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ReferralModeID tabeli Referral

Definicja kolumny ReferralModeID tabeli Referral

Name

ReferralModeID

Code

ReferralModeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExternalOrgUnitID tabeli Referral

Definicja kolumny ExternalOrgUnitID tabeli Referral

Name

ExternalOrgUnitID

Code

ExternalOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExternalDoctorID tabeli Referral

Definicja kolumny ExternalDoctorID tabeli Referral

Name

ExternalDoctorID

Code

ExternalDoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PreviousTreatmentPlaceID tabeli Referral

Definicja kolumny PreviousTreatmentPlaceID tabeli Referral

Name

PreviousTreatmentPlaceID

Code

PreviousTreatmentPlaceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ICDID tabeli Referral

Definicja kolumny ICDID tabeli Referral

Name

ICDID

Code

ICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli Referral

Definicja kolumny StartDT tabeli Referral

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Referral

Definicja kolumny StopDT tabeli Referral

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna VisitCount tabeli Referral

Definicja kolumny VisitCount tabeli Referral

Name

VisitCount

Code

VisitCount

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrderingCompanyStatisticalNo tabeli Referral

Definicja kolumny OrderingCompanyStatisticalNo tabeli Referral

Name

OrderingCompanyStatisticalNo

Code

OrderingCompanyStatisticalNo

Data Type

VARCHAR2(14)

Mandatory

No

Comment

 


Kolumna OrderingOrgUnitType tabeli Referral

Definicja kolumny OrderingOrgUnitType tabeli Referral

Name

OrderingOrgUnitType

Code

OrderingOrgUnitType

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna OrderingDoctor tabeli Referral

Definicja kolumny OrderingDoctor tabeli Referral

Name

OrderingDoctor

Code

OrderingDoctor

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna OrderingDoctorNo tabeli Referral

Definicja kolumny OrderingDoctorNo tabeli Referral

Name

OrderingDoctorNo

Code

OrderingDoctorNo

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna CustomerContractNo tabeli Referral

Definicja kolumny CustomerContractNo tabeli Referral

Name

CustomerContractNo

Code

CustomerContractNo

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna OrderingUnitID tabeli Referral

Definicja kolumny OrderingUnitID tabeli Referral

Name

OrderingUnitID

Code

OrderingUnitID

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna OrdDocumentNo tabeli Referral

Definicja kolumny OrdDocumentNo tabeli Referral

Name

OrdDocumentNo

Code

OrdDocumentNo

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Comments tabeli Referral

Definicja kolumny Comments tabeli Referral

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Charge tabeli Referral

Definicja kolumny Charge tabeli Referral

Name

Charge

Code

Charge

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna ExternalDocumentNo tabeli Referral

Definicja kolumny ExternalDocumentNo tabeli Referral

Name

ExternalDocumentNo

Code

ExternalDocumentNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna PerformingDoctor tabeli Referral

Definicja kolumny PerformingDoctor tabeli Referral

Name

PerformingDoctor

Code

PerformingDoctor

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RefusingExternalOrgUnitID tabeli Referral

Definicja kolumny RefusingExternalOrgUnitID tabeli Referral

Name

RefusingExternalOrgUnitID

Code

RefusingExternalOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

Wskazuje jednostke, która odmówila przyjecia pacjenta, zanim znalazl sie w szpitalu klienta. Na GUI powiazane z polem "Nie przyjety przez".


Kolumna ReferralDoctorID tabeli Referral

Definicja kolumny ReferralDoctorID tabeli Referral

Name

ReferralDoctorID

Code

ReferralDoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StatCode8thPartID tabeli Referral

Definicja kolumny StatCode8thPartID tabeli Referral

Name

StatCode8thPartID

Code

StatCode8thPartID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID specjalnosci jednostki organizacyjnej


Kolumna PersonID tabeli Referral

Definicja kolumny PersonID tabeli Referral

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID pacjenta dla którego jest wystawione skierowanie


Kolumna SourceEventID tabeli Referral

Definicja kolumny SourceEventID tabeli Referral

Name

SourceEventID

Code

SourceEventID

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator zdarzenia, z którego skierowanie zostalo utworzone.


Kolumna OccupationExamTypeID tabeli Referral

Definicja kolumny OccupationExamTypeID tabeli Referral

Name

OccupationExamTypeID

Code

OccupationExamTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Typ badania dla medycyny pracy na skierowaniu


Kolumna HospitalizationPurposeID tabeli Referral

Definicja kolumny HospitalizationPurposeID tabeli Referral

Name

HospitalizationPurposeID

Code

HospitalizationPurposeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Cel hospitalizacji


Kolumna DestinationOrgUnitID tabeli Referral

Definicja kolumny DestinationOrgUnitID tabeli Referral

Name

DestinationOrgUnitID

Code

DestinationOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ReceivedDT tabeli Referral

Definicja kolumny ReceivedDT tabeli Referral

Name

ReceivedDT

Code

ReceivedDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna IsInternal tabeli Referral

Definicja kolumny IsInternal tabeli Referral

Name

IsInternal

Code

IsInternal

Data Type

NUMBER(10)

Mandatory

No

Comment

Czy skierowanie jest wewnetrzne(1), zewnetrzne(0), inne skierowanie które juz jest w systenie(null).


Kolumna ExternalOrgUnitName tabeli Referral

Definicja kolumny ExternalOrgUnitName tabeli Referral

Name

ExternalOrgUnitName

Code

ExternalOrgUnitName

Data Type

VARCHAR2(128)

Mandatory

No

Comment

Nazwa szpitala/jednostki org. do której pacjent jest kierowany (przy skierowaniach zewnetrznych)


Kolumna Occupation tabeli Referral

Definicja kolumny Occupation tabeli Referral

Name

Occupation

Code

Occupation

Data Type

VARCHAR2(300)

Mandatory

No

Comment

Stanowisko pracy w przypadku skierowania do medycyny pracy


Kolumna IcdComment tabeli Referral

Definicja kolumny IcdComment tabeli Referral

Name

IcdComment

Code

IcdComment

Data Type

VARCHAR2(512)

Mandatory

No

Comment

komentarz do diagnozy ze skierowania


Kolumna Commentary tabeli Referral

Definicja kolumny Commentary tabeli Referral

Name

Commentary

Code

Commentary

Data Type

CLOB

Mandatory

No

Comment

Informacja o rozpoznaniu ze skierowania/uwagach do skierowania.


Lista kluczy tabeli Referral

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Referral

Definicja klucza Identifier_1 tabeli Referral

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment